Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	46633944
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.2 GiB
Average record size in memory	96.0 B

Variable types

DateTime	1
Categorical	2
Numeric	9

Alerts

`lat,lon` has a high cardinality: 2651 distinct values	High cardinality
`components.co` is highly overall correlated with `components.no2` and 3 other fields	High correlation
`components.no2` is highly overall correlated with `components.co` and 5 other fields	High correlation
`components.o3` is highly overall correlated with `components.no2`	High correlation
`components.so2` is highly overall correlated with `components.no2`	High correlation
`components.pm2_5` is highly overall correlated with `components.co` and 2 other fields	High correlation
`components.pm10` is highly overall correlated with `components.co` and 2 other fields	High correlation
`components.nh3` is highly overall correlated with `components.co` and 1 other fields	High correlation
`components.no` has 15286768 (32.8%) zeros	Zeros
`components.o3` has 1257649 (2.7%) zeros	Zeros
`components.nh3` has 1699413 (3.6%) zeros	Zeros

Reproduction

Analysis started	2023-01-11 10:14:04.939884
Analysis finished	2023-01-11 10:46:45.250778
Duration	32 minutes and 40.31 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

dt
Date

Distinct	17328
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	355.8 MiB

Minimum	2021-01-01 00:00:00
Maximum	2022-12-31 23:00:00

Histogram

Histogram with fixed size bins (bins=50)

main.aqi
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	355.8 MiB

1	23120252
2	15958819
3	3547273
4	2637846
5	1369754

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46633944
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

Most occurring characters

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46633944	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	46633944	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46633944	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	23120252	49.6%
2	15958819	34.2%
3	3547273	7.6%
4	2637846	5.7%
5	1369754	2.9%

components.co
Real number (ℝ)

Distinct	956
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	322.23665

Minimum	77.61
Maximum	7583.62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	77.61
5-th percentile	175.24
Q1	220.3
median	263.69
Q3	333.79
95-th percentile	674.25
Maximum	7583.62
Range	7506.01
Interquartile range (IQR)	113.49

Descriptive statistics

Standard deviation	221.0768
Coefficient of variation (CV)	0.6860697
Kurtosis	49.495009
Mean	322.23665
Median Absolute Deviation (MAD)	51.74
Skewness	5.4298716
Sum	1.5027166 × 10¹⁰
Variance	48874.951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
230.31	950270	2.0%
233.65	948983	2.0%
226.97	946941	2.0%
223.64	942458	2.0%
236.99	937625	2.0%
240.33	925674	2.0%
220.3	924791	2.0%
243.66	906438	1.9%
216.96	900053	1.9%
247	888640	1.9%
Other values (946)	37362071	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
77.61	1	< 0.1%
78.44	2	< 0.1%
80.94	3	< 0.1%
82.61	2	< 0.1%
83.45	1	< 0.1%
84.28	5	< 0.1%
85.12	1	< 0.1%
85.95	4	< 0.1%
86.78	3	< 0.1%
87.62	4	< 0.1%

Value	Count	Frequency (%)
7583.62	1	< 0.1%
7370	1	< 0.1%
6622.31	1	< 0.1%
6462.1	16	< 0.1%
6355.29	34	< 0.1%
6248.47	1	< 0.1%
6195.07	16	< 0.1%
6141.66	31	< 0.1%
6088.26	2	< 0.1%
6034.85	22	< 0.1%

components.no
Real number (ℝ)

Distinct	1461
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8372645

Minimum	0
Maximum	865.46
Zeros	15286768
Zeros (%)	32.8%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.13
Q3	0.98
95-th percentile	24.14
Maximum	865.46
Range	865.46
Interquartile range (IQR)	0.98

Descriptive statistics

Standard deviation	20.905834
Coefficient of variation (CV)	4.3218297
Kurtosis	127.84661
Mean	4.8372645
Median Absolute Deviation (MAD)	0.13
Skewness	9.3230792
Sum	2.2558072 × 10⁸
Variance	437.05388
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15286768	32.8%
0.01	1992832	4.3%
0.02	1005038	2.2%
0.03	737916	1.6%
0.04	596139	1.3%
0.05	524989	1.1%
0.06	499046	1.1%
0.07	466281	1.0%
0.08	448063	1.0%
0.09	429436	0.9%
Other values (1451)	24647436	52.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15286768	32.8%
0.01	1992832	4.3%
0.02	1005038	2.2%
0.03	737916	1.6%
0.04	596139	1.3%
0.05	524989	1.1%
0.06	499046	1.1%
0.07	466281	1.0%
0.08	448063	1.0%
0.09	429436	0.9%

Value	Count	Frequency (%)
865.46	16	< 0.1%
851.15	16	< 0.1%
808.24	16	< 0.1%
772.48	16	< 0.1%
765.32	16	< 0.1%
729.56	16	< 0.1%
715.26	15	< 0.1%
708.1	16	< 0.1%
700.95	28	< 0.1%
693.8	22	< 0.1%

components.no2
Real number (ℝ)

Distinct	1306
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.295924

Minimum	0.02
Maximum	460.62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0.02
5-th percentile	1.01
Q1	3.34
median	7.71
Q3	19.19
95-th percentile	63.06
Maximum	460.62
Range	460.6
Interquartile range (IQR)	15.85

Descriptive statistics

Standard deviation	22.486814
Coefficient of variation (CV)	1.3799042
Kurtosis	15.760183
Mean	16.295924
Median Absolute Deviation (MAD)	5.49
Skewness	3.1586302
Sum	7.5994322 × 10⁸
Variance	505.65681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.57	221117	0.5%
5.74	215291	0.5%
5.83	210790	0.5%
5.91	209397	0.4%
6	208694	0.4%
6.08	205486	0.4%
11.14	205277	0.4%
6.17	201904	0.4%
11.31	201442	0.4%
11.48	198665	0.4%
Other values (1296)	44555881	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	56	< 0.1%
0.03	186	< 0.1%
0.04	449	< 0.1%
0.05	770	< 0.1%
0.06	1100	< 0.1%
0.07	1417	< 0.1%
0.08	1839	< 0.1%
0.09	2269	< 0.1%
0.1	3113	< 0.1%
0.11	3296	< 0.1%

Value	Count	Frequency (%)
460.62	16	< 0.1%
449.66	62	< 0.1%
433.21	69	< 0.1%
416.76	83	< 0.1%
411.27	48	< 0.1%
405.79	62	< 0.1%
400.3	54	< 0.1%
394.82	72	< 0.1%
389.34	24	< 0.1%
378.37	74	< 0.1%

components.o3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1360
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.479011

Minimum	0
Maximum	823.98
Zeros	1257649
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.4
Q1	32.9
median	58.65
Q3	82.25
95-th percentile	125.89
Maximum	823.98
Range	823.98
Interquartile range (IQR)	49.35

Descriptive statistics

Standard deviation	40.484896
Coefficient of variation (CV)	0.66940407
Kurtosis	4.7504424
Mean	60.479011
Median Absolute Deviation (MAD)	24.68
Skewness	1.2158001
Sum	2.8203748 × 10⁹
Variance	1639.0268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1257649	2.7%
92.98	428300	0.9%
94.41	404396	0.9%
95.84	382415	0.8%
65.8	376007	0.8%
65.09	375258	0.8%
66.52	375136	0.8%
60.8	374798	0.8%
62.23	374760	0.8%
62.94	372934	0.8%
Other values (1350)	41912291	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1257649	2.7%
0.01	192447	0.4%
0.02	102880	0.2%
0.03	73136	0.2%
0.04	58981	0.1%
0.05	47758	0.1%
0.06	43477	0.1%
0.07	36569	0.1%
0.08	32011	0.1%
0.09	30756	0.1%

Value	Count	Frequency (%)
823.98	1	< 0.1%
732.42	1	< 0.1%
703.81	2	< 0.1%
663.76	3	< 0.1%
658.04	1	< 0.1%
652.31	15	< 0.1%
646.59	2	< 0.1%
640.87	19	< 0.1%
629.43	15	< 0.1%
629.42	3	< 0.1%

components.so2
Real number (ℝ)

Distinct	913
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8760128

Minimum	0
Maximum	125.89
Zeros	8794
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.19
Q1	0.73
median	1.61
Q3	3.34
95-th percentile	9.78
Maximum	125.89
Range	125.89
Interquartile range (IQR)	2.61

Descriptive statistics

Standard deviation	4.1221488
Coefficient of variation (CV)	1.433286
Kurtosis	39.742988
Mean	2.8760128
Median Absolute Deviation (MAD)	1.07
Skewness	4.825446
Sum	1.3411982 × 10⁸
Variance	16.992111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.95	274315	0.6%
0.51	264120	0.6%
1.94	262059	0.6%
0.54	261201	0.6%
0.57	259420	0.6%
1.97	257799	0.6%
0.6	257668	0.6%
2	254906	0.5%
0.63	253794	0.5%
0.66	250989	0.5%
Other values (903)	44037673	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8794	< 0.1%
0.01	58587	0.1%
0.02	83323	0.2%
0.03	93445	0.2%
0.04	98837	0.2%
0.05	113276	0.2%
0.06	115594	0.2%
0.07	123759	0.3%
0.08	133442	0.3%
0.09	138037	0.3%

Value	Count	Frequency (%)
125.89	2	< 0.1%
120.16	1	< 0.1%
119.21	1	< 0.1%
118.26	1	< 0.1%
117.3	2	< 0.1%
116.35	1	< 0.1%
114.44	1	< 0.1%
113.49	2	< 0.1%
112.53	1	< 0.1%
109.67	1	< 0.1%

components.pm2_5
Real number (ℝ)

Distinct	21689
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.418874

Minimum	0.5
Maximum	3928.36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0.5
5-th percentile	0.91
Q1	3
median	5.79
Q3	11.02
95-th percentile	34.36
Maximum	3928.36
Range	3927.86
Interquartile range (IQR)	8.02

Descriptive statistics

Standard deviation	17.340684
Coefficient of variation (CV)	1.6643529
Kurtosis	546.92787
Mean	10.418874
Median Absolute Deviation (MAD)	3.4
Skewness	10.435513
Sum	4.8587321 × 10⁸
Variance	300.69932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5	1020728	2.2%
2.44	49677	0.1%
2.17	49582	0.1%
2.42	49503	0.1%
2.4	49184	0.1%
2.74	49148	0.1%
2.15	48761	0.1%
2.63	48742	0.1%
2.48	48736	0.1%
2.19	48701	0.1%
Other values (21679)	45171182	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	1020728	2.2%
0.51	28900	0.1%
0.52	29833	0.1%
0.53	29205	0.1%
0.54	29387	0.1%
0.55	29369	0.1%
0.56	31354	0.1%
0.57	30415	0.1%
0.58	29510	0.1%
0.59	29883	0.1%

Value	Count	Frequency (%)
3928.36	1	< 0.1%
3842.74	1	< 0.1%
3422.77	1	< 0.1%
3284.55	1	< 0.1%
3167.91	1	< 0.1%
3078.2	1	< 0.1%
2911.62	1	< 0.1%
2878.22	1	< 0.1%
2778	1	< 0.1%
2651.44	1	< 0.1%

components.pm10
Real number (ℝ)

Distinct	24591
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.664832

Minimum	0.5
Maximum	3928.62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0.5
5-th percentile	1.32
Q1	4.49
median	8.92
Q3	16.55
95-th percentile	46.6
Maximum	3928.62
Range	3928.12
Interquartile range (IQR)	12.06

Descriptive statistics

Standard deviation	21.146175
Coefficient of variation (CV)	1.441965
Kurtosis	267.11637
Mean	14.664832
Median Absolute Deviation (MAD)	5.29
Skewness	7.7102106
Sum	6.8387895 × 10⁸
Variance	447.1607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.56	37465	0.1%
0.6	36677	0.1%
0.57	36074	0.1%
0.62	36032	0.1%
0.61	36010	0.1%
0.65	35994	0.1%
0.51	35942	0.1%
0.59	35935	0.1%
0.64	35624	0.1%
0.63	35607	0.1%
Other values (24581)	46272584	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	18154	< 0.1%
0.51	35942	0.1%
0.52	33480	0.1%
0.53	33550	0.1%
0.54	34522	0.1%
0.55	35458	0.1%
0.56	37465	0.1%
0.57	36074	0.1%
0.58	34767	0.1%
0.59	35935	0.1%

Value	Count	Frequency (%)
3928.62	1	< 0.1%
3843.06	1	< 0.1%
3422.97	1	< 0.1%
3284.94	1	< 0.1%
3168.33	1	< 0.1%
3081.83	1	< 0.1%
2915.84	1	< 0.1%
2881.86	1	< 0.1%
2778.41	1	< 0.1%
2651.75	1	< 0.1%

components.nh3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	580
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4414392

Minimum	0
Maximum	172.26
Zeros	1699413
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.03
Q1	0.29
median	0.7
Q3	1.58
95-th percentile	5.26
Maximum	172.26
Range	172.26
Interquartile range (IQR)	1.29

Descriptive statistics

Standard deviation	2.4913579
Coefficient of variation (CV)	1.7283822
Kurtosis	138.02426
Mean	1.4414392
Median Absolute Deviation (MAD)	0.5
Skewness	7.5952326
Sum	67219996
Variance	6.2068643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1699413	3.6%
0.27	438291	0.9%
0.28	431824	0.9%
0.55	414610	0.9%
0.14	410292	0.9%
0.25	408582	0.9%
0.34	405274	0.9%
0.59	396734	0.9%
0.36	392979	0.8%
0.2	386240	0.8%
Other values (570)	41249705	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1699413	3.6%
0.01	217986	0.5%
0.02	222140	0.5%
0.03	241559	0.5%
0.04	264547	0.6%
0.05	300983	0.6%
0.06	304057	0.7%
0.07	320969	0.7%
0.08	336093	0.7%
0.09	369033	0.8%

Value	Count	Frequency (%)
172.26	2	< 0.1%
147.94	5	< 0.1%
145.91	1	< 0.1%
141.86	1	< 0.1%
137.81	1	< 0.1%
135.78	7	< 0.1%
133.75	12	< 0.1%
131.73	16	< 0.1%
129.7	9	< 0.1%
128.69	6	< 0.1%

TRT_ID
Real number (ℝ)

Distinct	2693
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	146994.67

Minimum	20
Maximum	4005907
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	355.8 MiB

Quantile statistics

Minimum	20
5-th percentile	1199
Q1	5991
median	10320
Q3	25802
95-th percentile	56396
Maximum	4005907
Range	4005887
Interquartile range (IQR)	19811

Descriptive statistics

Standard deviation	713230.08
Coefficient of variation (CV)	4.8520811
Kurtosis	25.267716
Mean	146994.67
Median Absolute Deviation (MAD)	5071
Skewness	5.2209786
Sum	6.8549414 × 10¹²
Variance	5.0869715 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13756	17328	< 0.1%
8166	17328	< 0.1%
18475	17328	< 0.1%
6089	17328	< 0.1%
18099	17328	< 0.1%
6133	17328	< 0.1%
15142	17328	< 0.1%
7198	17328	< 0.1%
12504	17328	< 0.1%
7171	17328	< 0.1%
Other values (2683)	46460664	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	17304	< 0.1%
22	17304	< 0.1%
24	17304	< 0.1%
26	17304	< 0.1%
27	17304	< 0.1%
28	17304	< 0.1%
30	17304	< 0.1%
34	17304	< 0.1%
40	17328	< 0.1%
41	17328	< 0.1%

Value	Count	Frequency (%)
4005907	17328	< 0.1%
4005667	17304	< 0.1%
4005660	17304	< 0.1%
4005608	17328	< 0.1%
4005591	17304	< 0.1%
4005581	17328	< 0.1%
4005580	17328	< 0.1%
4005572	17304	< 0.1%
4005570	17328	< 0.1%
4005561	17328	< 0.1%

lat,lon
Categorical

Distinct	2651
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	355.8 MiB

40.6831,-74.0066	64969
37.881,-122.2999	58607
35.3074,-119.0981	56904
29.6553,-98.6263	52532
29.9208,-90.0791	51984
Other values (2646)	46348948

Length

Max length	17
Median length	16
Mean length	16.23421
Min length	12

Characters and Unicode

Total characters	757065231
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	47.4258,-122.2408
2nd row	32.8932,-97.4587
3rd row	40.8567,-73.1671
4th row	34.5199,-105.8701
5th row	39.7774,-104.8564

Common Values

Value	Count	Frequency (%)
40.6831,-74.0066	64969	0.1%
37.881,-122.2999	58607	0.1%
35.3074,-119.0981	56904	0.1%
29.6553,-98.6263	52532	0.1%
29.9208,-90.0791	51984	0.1%
30.2285,-81.5908	44063	0.1%
38.932,-77.2395	43370	0.1%
26.7065,-80.1281	42601	0.1%
27.8142,-82.6786	42575	0.1%
33.6941,-117.8257	42505	0.1%
Other values (2641)	46133834	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
40.6831,-74.0066	64969	0.1%
37.881,-122.2999	58607	0.1%
35.3074,-119.0981	56904	0.1%
29.6553,-98.6263	52532	0.1%
29.9208,-90.0791	51984	0.1%
30.2285,-81.5908	44063	0.1%
38.932,-77.2395	43370	0.1%
26.7065,-80.1281	42601	0.1%
27.8142,-82.6786	42575	0.1%
33.6941,-117.8257	42505	0.1%
Other values (2641)	46133834	98.9%

Most occurring characters

Value	Count	Frequency (%)
.	93267888	12.3%
1	80942156	10.7%
3	74738161	9.9%
7	62860405	8.3%
2	61045812	8.1%
4	57065366	7.5%
8	56286525	7.4%
9	52167849	6.9%
,	46633944	6.2%
-	46633944	6.2%
Other values (3)	125423181	16.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	570529455	75.4%
Other Punctuation	139901832	18.5%
Dash Punctuation	46633944	6.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	80942156	14.2%
3	74738161	13.1%
7	62860405	11.0%
2	61045812	10.7%
4	57065366	10.0%
8	56286525	9.9%
9	52167849	9.1%
6	43772211	7.7%
5	42604468	7.5%
0	39046502	6.8%

Other Punctuation

Value	Count	Frequency (%)
.	93267888	66.7%
,	46633944	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	46633944	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	757065231	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	93267888	12.3%
1	80942156	10.7%
3	74738161	9.9%
7	62860405	8.3%
2	61045812	8.1%
4	57065366	7.5%
8	56286525	7.4%
9	52167849	6.9%
,	46633944	6.2%
-	46633944	6.2%
Other values (3)	125423181	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	757065231	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	93267888	12.3%
1	80942156	10.7%
3	74738161	9.9%
7	62860405	8.3%
2	61045812	8.1%
4	57065366	7.5%
8	56286525	7.4%
9	52167849	6.9%
,	46633944	6.2%
-	46633944	6.2%
Other values (3)	125423181	16.6%

Auto

Heatmap
Table

	components.co	components.no	components.no2	components.o3	components.so2	components.pm2_5	components.pm10	components.nh3	TRT_ID	main.aqi
components.co	1.000	0.415	0.782	-0.424	0.460	0.604	0.540	0.504	-0.045	0.333
components.no	0.415	1.000	0.406	-0.180	0.359	0.357	0.339	0.315	-0.046	0.243
components.no2	0.782	0.406	1.000	-0.558	0.579	0.563	0.546	0.533	-0.083	0.334
components.o3	-0.424	-0.180	-0.558	1.000	-0.000	-0.219	-0.192	-0.223	0.003	0.375
components.so2	0.460	0.359	0.579	-0.000	1.000	0.443	0.416	0.277	-0.053	0.182
components.pm2_5	0.604	0.357	0.563	-0.219	0.443	1.000	0.939	0.385	-0.037	0.023
components.pm10	0.540	0.339	0.546	-0.192	0.416	0.939	1.000	0.379	-0.052	0.027
components.nh3	0.504	0.315	0.533	-0.223	0.277	0.385	0.379	1.000	-0.041	0.093
TRT_ID	-0.045	-0.046	-0.083	0.003	-0.053	-0.037	-0.052	-0.041	1.000	0.022
main.aqi	0.333	0.243	0.334	0.375	0.182	0.023	0.027	0.093	0.022	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	dt	main.aqi	components.co	components.no	components.no2	components.o3	components.so2	components.pm2_5	components.pm10	components.nh3	TRT_ID	lat,lon
0	2021-01-01	1	257.02	0.01	11.65	48.64	2.80	2.67	4.79	0.25	6838	47.4258,-122.2408
1	2021-01-01	1	230.31	0.00	5.66	60.80	0.65	0.68	0.86	0.12	35618	32.8932,-97.4587
2	2021-01-01	1	297.07	0.01	15.25	49.35	2.47	1.54	2.61	0.85	9852	40.8567,-73.1671
3	2021-01-01	1	183.58	0.07	2.21	75.82	0.14	2.88	5.23	1.17	17801	34.5199,-105.8701
4	2021-01-01	2	403.88	3.21	67.17	13.77	1.64	16.76	21.83	1.82	35905	39.7774,-104.8564
5	2021-01-01	1	323.77	0.02	21.59	57.22	2.56	5.97	7.41	3.61	34155	45.0462,-93.3921
6	2021-01-01	4	540.73	3.16	54.15	80.11	10.97	44.67	51.60	0.40	5773	32.5869,-117.0917
7	2021-01-01	2	210.29	0.20	2.27	94.41	0.52	3.11	3.98	0.35	31177	34.6133,-118.1406
8	2021-01-01	1	257.02	0.00	6.86	65.80	1.03	0.59	1.20	0.55	58602	41.0784,-74.1667
9	2021-01-01	2	360.49	2.68	34.96	80.11	9.30	13.26	16.72	1.87	5723	33.7245,-117.7962

	dt	main.aqi	components.co	components.no	components.no2	components.o3	components.so2	components.pm2_5	components.pm10	components.nh3	TRT_ID	lat,lon
46633934	2022-12-31 23:00:00	1	260.35	0.22	12.51	20.56	0.78	3.94	4.99	0.35	26391	30.5102,-87.2174
46633935	2022-12-31 23:00:00	1	360.49	4.58	27.08	4.65	1.68	5.27	6.78	0.30	20899	37.4123,-122.1479
46633936	2022-12-31 23:00:00	1	240.33	0.29	14.57	45.06	4.95	2.25	3.38	0.51	9971	34.0851,-118.1406
46633937	2022-12-31 23:00:00	1	196.93	0.06	1.78	53.64	0.29	1.27	2.03	0.04	25076	34.1533,-118.7617
46633938	2022-12-31 23:00:00	1	453.95	4.75	39.76	4.16	1.48	8.39	11.31	0.91	13557	42.3967,-83.2776
46633939	2022-12-31 23:00:00	1	310.42	1.29	27.76	16.45	2.62	3.44	4.56	0.49	34595	37.4255,-121.9754
46633940	2022-12-31 23:00:00	2	333.79	1.58	22.96	55.07	6.08	16.04	20.21	0.99	24894	30.0194,-95.2863
46633941	2022-12-31 23:00:00	1	267.03	0.66	15.77	32.54	1.62	2.85	3.86	0.35	856	47.6294,-122.1478
46633942	2022-12-31 23:00:00	2	213.62	0.08	3.90	63.66	0.26	0.60	0.81	0.16	677	37.9634,-122.516
46633943	2022-12-31 23:00:00	1	213.62	0.08	2.78	53.64	0.31	2.41	4.53	0.14	45308	32.6972,-117.134

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample